export const ProjectMembersQueries = {
    GetProjectMembers: `
    SELECT
      id,
      projectId,
      projectMemberId
    FROM my_schema.project_members
    `,
  
    GetProjectMembersById: `
    SELECT
      id,
      projectId,
      projectMemberId
    FROM my_schema.project_members
    WHERE
      id = ?
    `,

    GetProjectMembersByProjectId: `
    SELECT
      id,
      projectId,
      projectMemberId
    FROM my_schema.project_members
    WHERE
      projectId = ?
    `,

    GetProjectsByMemberId: `
    SELECT
      id,
      projectId,
      projectMemberId
    FROM my_schema.project_members
    WHERE
      projectMemberId = ?
    `,
  
    AddProjectMembers: `
    INSERT INTO my_schema.project_members (projectId, projectMemberId)
      VALUES ?
    `,
  
    DeleteProjectMembersByProjectId: `
    DELETE FROM my_schema.project_members
    WHERE
      projectId = ?
    `
  };